<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.springblade.demo05.mapper.IdiomsMapper">
  <select id="getAllIdioms" parameterType="string" resultType="org.springblade.demo05.entity.Idioms">
    <!-- 这里由于数据库中存在重复的成语，因此就对其进行分组而达到去重的效果-->
    select * from idioms where `name` like #{name} group by name
  </select>
</mapper>